Finishing work with sorting and filtering range
To finish working with the current sorting and filtering range, do one of the following:
–On the Home tab, in the Data, click 
Filter.
–On the Data tab, click Filter.
–Right-click the selected range and select Filter from the context menu.
–Press Ctrl+Shift+L (Windows, Linux) or ⌘Cmd+⇧Shift+L (macOS).
|
When you finish working with a range, only the sorting results will be saved in the spreadsheet. Filtering results are not saved. |
